﻿--Default Values

SET QUOTED_IDENTIFIER ON;
GO
SET ANSI_NULLS ON;
GO

-- Insert Stock
-- Insert Orders
INSERT INTO OrderSet(Id, OrderedQuantity, DeliveredQuantity, RemainedQuantity)
	VALUES(5, 300, 300, 200)
INSERT INTO OrderSet(Id, OrderedQuantity, DeliveredQuantity, RemainedQuantity)
	VALUES(6, 100, 100, 100)
INSERT INTO OrderSet(Id, OrderedQuantity, DeliveredQuantity, RemainedQuantity)
	VALUES(7, 600, 600, 300)

-- Insert External Stock
INSERT INTO ExternalOrderSet(Unit, Price, CreationDate, HarvestDate, WantedQuantity, ProvidedQuantity, AmapExternalOrderId, ProductId, AmapId, RemainedQuantity)
	VALUES('barquette de 500g', 1.2, GETDATE() - 7, GETDATE() - 7, 800, 500, 28, (select top 1 Id from ProductSet where name = 'Champignons de paris'), 2, 400)
	